Totals Overview

Totals Overview

Totals provides a powerful mechanism for displaying various types of totals in the query and grid. Totaling in BI Office allows complex capabilities to portray additive, non-additive and semi-additive measures. There are special techniques for handling hierarchical and partial data in queries - so that the totals can portray varied options when looking at complex, multi-layered, multi-dimensional queries.

Totals Commands

To access the totals commands, click the Totals icon in the Home or Query ribbon.

• Totals - Described below.
• Totals (Top) - Described below.
• Optimize Totals - See Advanced Totals Options topic.
• More Total Options - See Working with Totals topic.
• Hide Totals - Removes all totals from the query.

Totals

The following commands position totals AFTER the data being totaled. For command descriptions, see Working with Totals.

Totals (Top)

The following commands position totals BEFORE the data being totaled. For command descriptions, see Working with Totals.

Accessing Totals from Context Menus

Right-click a report component and choose Totals from the context menu to access the following commands. For command descriptions, see Working with Totals.